[dbo].[Name_FRTransactionLog]

Property	Value
Created	11:09:01 AM Friday, August 06, 2010
Last Modified	11:40:04 AM Monday, February 20, 2012

Property

Value

Created

11:09:01 AM Friday, August 06, 2010

Last Modified

11:40:04 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_Name_FRTransactionLog: ID\SEQN$	ID	varchar(10)	10
$Cluster Primary Key PK_Name_FRTransactionLog: ID\SEQN$	SEQN	int	4
	TransactionID	varchar(25)	25
	TransactionType	varchar(25)	25
	EventID	varchar(100)	100
	ConstituentID	varchar(25)	25
	DateImported	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_Name_FRTransactionLog: ID\SEQN$

varchar(10)

$Cluster Primary Key PK_Name_FRTransactionLog: ID\SEQN$

SEQN

int

TransactionID

varchar(25)

TransactionType

varchar(25)

EventID

varchar(100)

100

ConstituentID

varchar(25)

DateImported

datetime

	Name	Columns	Unique
$Cluster Primary Key PK_Name_FRTransactionLog: ID\SEQN$	PK_Name_FRTransactionLog	ID, SEQN
	IX_Name_FRTransactionLog_TransactionID	TransactionID

Name

Columns

Unique

$Cluster Primary Key PK_Name_FRTransactionLog: ID\SEQN$

PK_Name_FRTransactionLog

ID, SEQN

IX_Name_FRTransactionLog_TransactionID

TransactionID

SQL Script

CREATE TABLE [dbo].[Name_FRTransactionLog]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SEQN] [int] NOT NULL,
[TransactionID] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TransactionType] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EventID] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ConstituentID] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DateImported] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Name_FRTransactionLog] ADD CONSTRAINT [PK_Name_FRTransactionLog] PRIMARY KEY CLUSTERED ([ID], [SEQN]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Name_FRTransactionLog_TransactionID] ON [dbo].[Name_FRTransactionLog] ([TransactionID]) ON [PRIMARY]
GO